Devart is a great tool for the cost
Devart Excel Add-ins is being used at my organization to help manage a few different SQL server management tasks including but not limited …
Starting at $119.95
View PricingOverview
What is Devart Excel Add-ins?
Devart Excel Add-ins allow you to use Excel capabilities to import, process, and analyze data from cloud applications and relational databases. The Excel Add-ins also allow users to make data changes and then save those changes back to the data…
Recent Reviews
Pricing
Standard Edition
$119.95
On Premise
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://www.devart.com/excel…
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Details
- About
- Integrations
- Tech Details
What is Devart Excel Add-ins?
Devart Excel Add-ins allow users to work with database and cloud data in Microsoft Excel as with usual Excel spreadsheets.
With Devart Excel Add-ins users can get data with a visual Query Builder or with SQL and refresh the queried external data in a workbook. External data can be edited as it is usually done in Excel, and then saved back to the data source.
Supported databases:
- Oracle Database
- SQL Server
- MySQL
- PostgreSQL
- SQLite
- DB2
Supported Cloud Applications:
- BigCommerce
- Dynamics CRM
- FreshBooks
- Freshdesk
- G Suite
- HubSpot
- Magento
- MailChimp
- Marketo
- NetSuite
- QuickBooks
- Salesforce
- Salesforce Marketing Cloud
- Shopify
- SugarCRM
- Zendesk
- Zoho CRM
Devart Excel Add-ins Features
- Supported: Connect Microsoft Excel to various data sources
- Supported: Work with live data directly in Excel
- Supported: Modify external data easily
- Supported: Powerful Data Import. With Devart Excel Add-ins you can precisely configure what data to load into the document. Select objects and columns and set complex data filters. If this is not enough, all the power of SQL is to your service, not only for relational databases, but for cloud applications too.
- Supported: Quick Data Refresh. The main Devart Excel Add-ins benefit is an ability to periodically get the actual data from different data sources to Excel with a single click without repeating the whole import operation each time. Refresh data in your workbook easily whenever you want.
- Supported: Easy Data Modification. You can edit data in Excel just like you usually do it, add or delete rows, modify cell values, etc. Use full power of Excel to perform mass data update, insert, and delete operations against your data source. After you finished editing, just click Commit and the changes will be posted back to the data source.
Devart Excel Add-ins Screenshots
Devart Excel Add-ins Integrations
- Zoho CRM
- Sugar Sell (SugarCRM)
- Microsoft SQL Server
- MySQL
- Oracle Database (legacy)
- PostgreSQL
- SQLite
- Db2
- Mailchimp
- QuickBooks Online
- Microsoft Dynamics 365
- BigCommerce
- FreshBooks
- Freshdesk
- Adobe Marketo Engage
- Shopify
- Salesforce CRM
- Zendesk
- G Suite
- HubSpot
- Magento
- NetSuite
- Salesforce Marketing Cloud
- SugarCRM
Devart Excel Add-ins Technical Details
| Deployment Types | On-premise |
|---|---|
| Operating Systems | Windows |
| Mobile Application | No |
| Supported Languages | English |
Comparisons
Compare with
Reviews and Ratings
(29)Reviews
(1-1 of 1)Companies can't remove reviews or game the system. Here's why
April 23, 2021
Devart is a great tool for the cost
Devart Excel Add-ins is being used at my organization to help manage a few different SQL server management tasks including but not limited to - source control, unit testing, schema comparisons, event profiling, dev ops automation, index management analysis and query builder. There are more use cases for the Devart Excel Add-ins above and beyond what we are using it for.
- Source control
- Unit testing
- Schema comparisons
- The data pump feature breaks sometimes
- The profile usage monitoring is slow
- The event profiler is delayed
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
- The data compare option saves our dev team a lot of time
- The documenter feature is nice to use for explaining table definitions
- The event profiler is great for usage metrics
Microsoft Excel is the most used tool in the software universe. As such, asking Microsoft Excel to be the tool used post data acquisition makes a ton of sense. Almost everyone we hire has some idea on how to use this tool, which decreases the time spend training new employees.